Tables [dbo].[MatchingGiftPlanRule]
SQLServer > iMIS1521GA > Tables > dbo.MatchingGiftPlanRule
Properties
PropertyValue
Row Count0
Created10:31:27 AM Tuesday, March 02, 2010
Last Modified1:17:33 PM Thursday, February 23, 2012
Columns
NameData TypeMax Length (Bytes)Allow Nulls
Cluster Primary Key PK_MatchingGiftPlanRule: MatchingGiftPlanRuleKeyMatchingGiftPlanRuleKeyuniqueidentifier16
No
Foreign Keys FK_MatchingGiftPlanRule_MatchingGiftPlan: [dbo].[MatchingGiftPlan].MatchingGiftPlanKeyIndexes IX_MatchingGiftPlanRule_MatchingGiftPlanKey: MatchingGiftPlanKeyMatchingGiftPlanKeyuniqueidentifier16
No
RuleKeyuniqueidentifier16
No
MarkedForDeleteOndatetime8
Yes
Indexes Indexes
NameColumnsUnique
Cluster Primary Key PK_MatchingGiftPlanRule: MatchingGiftPlanRuleKeyPK_MatchingGiftPlanRuleMatchingGiftPlanRuleKey
Yes
IX_MatchingGiftPlanRule_MatchingGiftPlanKeyMatchingGiftPlanKey
Foreign Keys Foreign Keys
NameColumns
FK_MatchingGiftPlanRule_MatchingGiftPlanMatchingGiftPlanKey->[dbo].[MatchingGiftPlan].[MatchingGiftPlanKey]
SQL Script
CREATE TABLE [dbo].[MatchingGiftPlanRule]
(
[MatchingGiftPlanRuleKey] [uniqueidentifier] NOT NULL,
[MatchingGiftPlanKey] [uniqueidentifier] NOT NULL,
[RuleKey] [uniqueidentifier] NOT NULL,
[MarkedForDeleteOn] [datetime] NULL
) ON [PRIMARY]

GO
ALTER TABLE [dbo].[MatchingGiftPlanRule] ADD CONSTRAINT [PK_MatchingGiftPlanRule] PRIMARY KEY CLUSTERED ([MatchingGiftPlanRuleKey]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_MatchingGiftPlanRule_MatchingGiftPlanKey] ON [dbo].[MatchingGiftPlanRule] ([MatchingGiftPlanKey]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[MatchingGiftPlanRule] ADD CONSTRAINT [FK_MatchingGiftPlanRule_MatchingGiftPlan] FOREIGN KEY ([MatchingGiftPlanKey]) REFERENCES [dbo].[MatchingGiftPlan] ([MatchingGiftPlanKey])
GO
Uses
Created 05 April 2012 11:11
Copyright  2012 - All Rights Reserved